soumi bhattacharyya
Public
0/140
30.0 seconds
Continue clipping after ad finishes
Can’t create clip while ad is playing
Data Analyst Portfolio Project | SQL Data Exploration | Project 1/4
Alex The Analyst
21K Likes
1,051,892 Views
2021 May 4
Today we start our Data Analyst Portfolio Project Series. In our first project we will be using SQL to do some Data Exploration. We will then visualize the data in Tableau for our next project. Link to GitHub: https://bit.ly/3xNwzGK Link to Dataset: https://ourworldindata.org/covid-deaths ** It appears the dataset may have been changed at the source. Please use these 2 links to get the data from the 2 excels: 1. Covid Deaths: https://github.com/AlexTheAnalyst/Por... 2. Covid Vaccinations: https://github.com/AlexTheAnalyst/Por... ____________________________________________ SUBSCRIBE! Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________ RESOURCES: Coursera Courses: Google Data Analyst Certification: https://coursera.pxf.io/5bBd62 Data Analysis with Python - https://coursera.pxf.io/BXY3Wy IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR Tableau Data Visualization - https://coursera.pxf.io/MXYqaN Udemy Courses: Python for Data Analysis and Visualization- https://bit.ly/3hhX4LX Statistics for Data Science - https://bit.ly/37jqDbq SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij Tableau A-Z - http://bit.ly/385lYvN Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel! ____________________________________________ SUPPORT MY CHANNEL - PATREON/MERCH Patreon Page - https://www.patreon.com/AlexTheAnalyst Alex The Analyst Shop - https://teespring.com/stores/alex-the... ____________________________________________ Websites: GitHub: https://github.com/AlexTheAnalyst ____________________________________________ All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for 0:00 Introduction 1:43 Getting Out Dataset 6:41 Importing Datasets into SQL 13:40 Data Exploration 1:13:35 Import Code into GitHub
ARTIST
Birocratic
ALBUM
Memory Card Full
LICENSES
Get YouTube Premium

Next:How To Become A Data Analyst In 2022

YouTube

Data Analyst Portfolio Project | SQL Data Exploration | Project 1/4

Alex The Analyst

How To Become A Data Analyst In 2022

Alex The Analyst

How To Get a Data Analyst Job (with No Experience)

Alex The Analyst

SQL Basics Tutorial For Beginners | Installing SQL Server Management Studio and Create Tables | 1/4

Alex The Analyst

Data Scientist vs Data Analyst | Which Is Right For You?

Alex The Analyst

How to use Drill Down in Power BI | Microsoft Power BI for Beginners

Alex The Analyst

Google vs IBM Data Analytics Certificates | Which is Better?

Alex The Analyst

How to use Conditional Formatting in Power BI | Microsoft Power BI for Beginners

Alex The Analyst

How to Create a Portfolio Website for FREE

Alex The Analyst

How to Become a Data Analyst in 2023 (Completely FREE!)

Alex The Analyst

Data Analyst vs Business Analyst | Which Is Right For You?

Alex The Analyst

Google Data Analytics Professional Certificate | It's Finally Here!

Alex The Analyst

Popular Visualizations in Power BI | Microsoft Power BI for Beginners

Alex The Analyst

What Does a Data Analyst Actually Do?

Alex The Analyst

Top 5 Reasons Not to Become a Data Analyst

Alex The Analyst

How to use Power Query in Power BI | Microsoft Power BI for Beginners

Alex The Analyst

Cleaning Data in Excel | Excel Tutorials for Beginners

Alex The Analyst

How to use DAX in Power BI | Microsoft Power BI for Beginners

Alex The Analyst

How I Changed Careers to Become a Data Analyst | Alex The Analyst Show | Episode 2

Alex The Analyst

Why You Need to Stop Taking Courses (From an Ex-Course Addict)

Alex The Analyst

Data Analyst Career Path | How to Become a Data Analyst + What to Do Next

Alex The Analyst

How to Install Power BI | Building First Visualization | Microsoft Power BI for Beginners

Alex The Analyst

How to Install Tableau and Create First Visualization | Tableau Tutorials for Beginners

Alex The Analyst

Database vs Data Warehouse vs Data Lake | What is the Difference?

Alex The Analyst

Advanced SQL Tutorial | Temp Tables

Alex The Analyst
I'm doing this in Oct 2021 and apparently one of the code chunks where you need to convert new_vaccinations column to integer, the sum value now has exceeded 2,147,483,647. So instead of converting it to "int", you will need to convert to "bigint". Hope this helps everyone.
1K
I just completely watched this priceless video. Many thanks Alex for teaching us free of cost and guiding us all along. I am an Economist and have been learning data analysis since 2022 and it is amazing that I have found your channel and you.
2
This was a lifesaver when I needed a portfolio quickly for a job interview while still being a beginner. It was easy to follow and I could base my own projects on it. This definitely was part of me getting the job!
142
Man... you're amazing. Don't congratulate us to have stayed until the end! It's TONS of work you've done and it's only to be applauded and appreciated! I bet many agree with me - against your sore throat you guided us through soooo many ideas and possibilities! Thank you so much and wish you MILLIONS views!
55
I did data analysis and error management in a HUGE database for sprint. The work I did was extremely similar to this. The database was way messier and more confusing than this, but if you can work out the problems as you go like he is, this is basically what I did everyday.
5
I now have my very own github profile with a fairly impressive first project on it, with more to come now that I know how it works. Huzzah! Alex, you're a stud. Thanks for what you do.
1
I’ve just started the video and I’m about 9 minutes in. I wanted to stop at this point to tell you I’m glad you showed your mistake live. It’s important for beginners to see that experts also make mistakes. It is encouraging. As a bonus, I will better remember to save as xlsx because you pointed it out. So thank you for leaving that in.
427
What I really want to thank you for is making this real. I mean, keeping all your own mistakes in the video is a booster for Aspiring Analysts like myself. "Yes, it can get messy. We just need to keep calm and figure it out". Thanks once again, Alex
39
This has been beyond helpful! I've been taking lots of SQL classes at Datacamp, and as you mentioned in your video on Datacamp, one of the drawbacks is not necessarily knowing how to apply the concepts within the software. This helped me feel a lot more confident navigating and applying concepts with SQL Server :)
44
I can’t express how much I appreciate you creating these tutorials. As a beginner prospective analyst looking to add projects to a portfolio, I was lost and overwhelmed. Your videos are a godsend. Thanks a lot
35
In order to avoid having to include the WHERE clause for the continent column in each query, I just made a whole new COVID_Deaths table called COVID_Deaths1 that includes the clause and then I used the newly made table in all subsequent queries. Hope this helps. Also, thanks a lot, Alex. This is really cool.
2
Great content, as per. You helped me to get my dream job as a modelling analyst in the last couple of weeks, I am forever grateful to you!
482
This is SO helpful, thanks Alex! For anyone looking for the intermediate-level SQL queries, they're near the end – here are the timestamps: 51:20 Joins 62:00 CTEs 66:30 Temp tables 70:20 Views
6
For anyone using Azure Data Studio and having trouble importing the CSV files with the SQL Import extension. You will need to change around with the Data Types that Azure identifies. e.g. change Small Int to Int or nvarchar(1) to nvarchar(50). In addition, I made all columns to allow null values. Making these corrections then worked and both CSV files imported into my database.
1
This is a fantastic video, thanks for helping me and countless others in pursuing our goals! Making mistakes is totally fine but you saying '.. so I don't waste everyone's time' just makes me appreciate this even more. Idk what benefits you get from making these videos, but I hope life will reward you much more for all your hard work. Bless you and keep rockin' Alex!
1
Hi Alex. Great content. Can you also give a brief overview of what you will be doing, such as what data you will be extracting and what you will do with that data at the beginning of each video so we can get a better picture and maybe try to map out first how we would go about solving such problems first? Thank you :)
5
I just started learning sql 2 days ago, and now I'm doing my first project with your help! So easy to understand!
7
Just when I thought this guy has done a great deal of work for beginners like me, he goes on to do greater things like this. Really thank you Alex -from an aspiring analyst
72
Thank you for doing this! This has been extremely helpful
1
This is my first project on SQL. I couldn't have done without you. Thanks a lot
6